package com.tyh.management.mapper;

import java.util.List;
import java.util.Map;

import com.tyh.management.entity.Scores;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

@Mapper
public interface GcCourseMapper {
	public List<Scores>findScores(String coursename, String gcg, String gcc, int start, int pagesize );
	public List<Scores>findAllScores(String coursename,String gcg,String gcc);
	public List<Scores>compClaScores(String coursename,String gcg);
	public int updateScores(Map map);
	public List<Scores> findPersonScore(String coursename,String num);





	@Delete("delete from stu_sco where stuno = #{num} and courseid = #{course}")
    int delete(@Param("num")String num, @Param("course")String course);
}
